Apply to Row (AND) – Multiple

This function facilitates the application of a preferred format (e.g., highlighting, bolding, italics, etc.) to either a row, a column, or individual cells, contingent upon the satisfaction of particular conditions. In this specific instance, it will be employed on a row, but only if the row fulfills multiple conditions through the utilization of the "AND" function.

To apply conditional formatting, begin by dragging the selected report into your browser. After it loads, click the 'Actions' button. From the dropdown menu, select 'Conditional formatting' and then 'Add condition'. Specify an order date and a particular condition. Enter the necessary data and click 'Add new condition'. Make sure the 'AND' option is selected to combine both conditions. Then, enter the data for the second condition and choose the desired format and style. Finally, click 'Apply' to view the changes in your report.

Preview